{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Existing ACV and VMF Scoring","Input Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Existing ACV and VMF Scoring","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,2,50,4],[14,1,14,5],[1,1,1,5],[12,1,12,4],[49,1,49,4],[2,1,2,5],[4,1,4,2],[13,1,13,5],[15,1,15,2],[41,2,41,4],[36,2,36,4],[31,2,31,4],[26,2,26,4],[20,2,20,4],[16,2,16,4],[46,2,46,4]]}
[]
[null,"Airport Community Value Scoring Matrix"]
[]
[null,"Airport Name"]
[null,null,null,"Direct","Indirect","Total"]
[null,"Existing IMPLAN Values","Derived from existing TxDOT 2005 study or new effort"]
[null,"   Airport Jobs","Show Direct, Indirect, and Total",null,null,{"$f":"SUM(D7:E7)","v":0}]
[null,"   Total Output","Show Direct, Indirect, and Total",null,null,{"$f":"SUM(D8:E8)","v":0}]
[null,"   Tax Contribution","Derived from existing 2005 study or new effort",null,null,{"$f":"SUM(D9:E9)","v":0}]
[null,"Existing Airport Replacement Value","See Input Sheet \"Airport Replacement Value\" for Details",null,null,{"$f":"'Input Sheet'!F25","v":0}]
[null,"Existing Airport Value w/Depreciation","See Input Sheet \"Existing/Depreciated Airport Value\" for Details",null,null,{"$f":"'Input Sheet'!F50","v":0}]
[]
[null,"Subtotal Existing ACV ",null,null,null,{"$f":"+F8+F11","v":0}]
[]
[null,"Value Modifying Factors"]
[null,null,null,"Input Value",null,"Factor Score"]
[null,"Regional Airport Resource Factor","Maximum Factor Score = 4",null,null,{"$f":"+(D19/3566361)*D18","v":0}]
[null,"   Airport Classification","Use Classes 1 - 4 (Not Military or Airline)",{"$nulls":4},"* F&G=4, E=3, D=2, A&B&C=1"]
[null,"   Population in Service Area","Use NCTCOG Data for Each System Airport"]
[]
[null,"Airport Protection Factor","Maximum Factor Score = 4",null,null,{"$f":"+(D24*0.25)+D22+D23+D25","v":0}]
[null,"   Control of Runway Protection Zone","1=Yes, 0=No"]
[null,"   Runway Safety Areas in Place","1=Yes, 0=No"]
[null,"   Land Use Compatibility","1 Point for Each Quadrant"]
[null,"   Height Hazard Zoning for Airport","1=Yes, 0=No"]
[]
[null,"Location/Access","Maximum Factor Score = 4",null,null,{"$f":"+IF(ISERROR(D30*D29),0,(D30*D29))","v":0}]
[null,"   Surface Access Infrastructure",".25=Local Arterial, .5=Regional Arterial,"]
[null,null,".75=Limited Access State Road, 1=Interstate"]
[null,"   Location Relative to Economic Centers","1 to 3 Miles=4, 4 to 6 Miles=3, 7 to 9 Miles=2, over 9=1"]
[]
[null,"Business Use Index","Maximum Factor Score = 8",null,null,{"$f":"+D33+((D34/199)*2)+((D35/126238)*2)","v":0}]
[null,"   Airport Classification","Use Classes 1 - 4 (Not Military or Airline)"]
[null,"   Business Aviation Activity","# Based Business Jets"]
[null,null,"# Itinerant Operations"]
[]
[null,"Expandability Factor","Maximum Factor Score = 4",null,null,{"$f":"+(D38+D39+D40)/3","v":0}]
[null,"   On-Airport Expandability","Airside 1 to 4 using 1 pt. for 100%, 3 pts for 50%, etc."]
[null,null,"Landside 1 to 20 acres=1pt., 2 pts for 21 to 100 acres, etc"]
[null,"   Off-Airport Expandability","1 to 4 using 4 pts. for 100%, 2 pts. for 50% etc."]
[]
[null,"Community Commitment Factor","Maximum Factor Score = 4",null,null,{"$f":"+(D43+D45)/2","v":0}]
[null,"   Current Plans on File","1 pt. for each - ACIP, Master Plan, Airport Zoning, Business Plan"]
[null,"   Funding History and Frequency","Airport Operating Subsidy=2 pts., Annual Capital Funding=2 pts.,"]
[null,null,"Less Than Annual Capital Funding, 1 pt."]
[]
[null,"Airspace Rating Factor","Maximum Factor Score = 4",null,null,{"$f":"+D48","v":0}]
[null,null,"1 pts. for 0-10NM from DFW, 2 pts for 11-15NM"]
[null,null,"3 pts. for 16-20NM, and 4 pt. for 21+ NM"]
[null,"Total VMF Scoring",null,null,null,{"$f":"SUM(F17:F47)","v":0}]
[null,null,"Maximum Factor Score = 32"]

{"sheet":"Input Sheet","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,4],[0,0,0,5],[1,0,1,5],[24,0,24,4],[27,0,27,5],[28,0,28,5]]}
["Airport Replacement Value Input Sheet"]
[]
[null,"Description","Units",null,"Cost/Number","Amount"]
["Land Value","Acreage from 5010",null,"Cost/Acre",null,{"$f":"+C4*E4","v":0}]
[]
["Pavement"]
["  Runway","Length x Width",null,"Cost/SF",16,{"$f":"+C7*E7","v":0}]
["  Taxiway","1=Full, 2=Partial, 3=None",null,null,null,{"$f":"IF(E8=1, F7*0.5, IF(E8=2, F7*0.25, IF(E8=3, F7*0,)))","v":0}]
["  Apron Area","Area from Aerial",null,"Cost/SF",16,{"$f":"+C9*E9","v":0}]
[]
["Hangars"]
["  Conventional Hangars","Total Square Footage",null,"Cost/SF",120,{"$f":"+C12*E12","v":0}]
["  T-Hangars","Total Units",null,"Cost/Unit",75000,{"$f":"+C13*E13","v":0}]
[]
["Fuel System","0=None, 1=AvGas Only "]
[null," 2=AvGas & Jet A",null,null,null,{"$f":"IF(E16=0, 0, IF(E16=1, 250000, IF(E16=2, 500000,)))","v":0}]
[]
["Instrument Approaches","0=None, 1=Nonprecision"]
[null,"2=Precision",null,null,null,{"$f":"IF(E19=0, 0, IF(E19=1, 500000, IF(E19=2, 1500000,)))","v":0}]
[]
["Air Traffic Control Tower","0=No, 1=Yes",null,null,null,{"$f":"IF(E21=0, 0, IF(E21=1, 2000000))","v":0}]
[]
["Non-Hangar Buildings","Total Square Feet from Aerial",null,"Cost/SF",230,{"$f":"+C23*E23","v":0}]
[]
["Total Replacement Value",{"$nulls":4},{"$f":"SUM(F4:F24)","v":0}]
[]
[]
["Existing/Depreciated Airport Value Input Sheet"]
[]
[null,"Age of Existing Facilities"]
["Land Value","N/A",null,null,null,{"$f":"+F4","v":0}]
[]
["Pavement (Square Feet)","0-5 Years Old","6-10Y"," 11-20Y","Over 20Y"]
["  Runway",{"$nulls":4},{"$f":"+IF(ISERROR((((B34/C7)*$F7*0.875)+(C34/C7)*$F7*0.625)+(D34/C7)*$F7*0.25),0,((((B34/C7)*$F7*0.875)+(C34/C7)*$F7*0.625)+(D34/C7)*$F7*0.25))","v":0}]
["  Taxiway","N/A",null,null,null,{"$f":"+IF(ISERROR((F34/F7)*F8),0,((F34/F7)*F8))","v":0}]
["  Apron Area",{"$nulls":4},{"$f":"+IF(ISERROR((((B36/C9)*$F9*0.875)+(C36/C9)*$F9*0.625)+(D36/C9)*$F9*0.25),0,((((B36/C9)*$F9*0.875)+(C36/C9)*$F9*0.625)+(D36/C9)*$F9*0.25))","v":0}]
[]
["Hangars"]
["  Conventional Hangars (SF)",{"$nulls":4},{"$f":"+IF(ISERROR(((((B39/C12)*$F12*0.9375)+(C39/C12)*$F12*0.8125)+(D39/C12)*$F12*0.625)+(E39/C12)*$F12*0.33),0,(((((B39/C12)*$F12*0.9375)+(C39/C12)*$F12*0.8125)+(D39/C12)*$F12*0.625)+(E39/C12)*$F12*0.33))","v":0}]
["  T-Hangars (# of Units)",{"$nulls":4},{"$f":"+IF(ISERROR(((((B40/C13)*$F13*0.9375)+(C40/C13)*$F13*0.8125)+(D40/C13)*$F13*0.625)+(E40/C13)*$F13*0.33),0,(((((B40/C13)*$F13*0.9375)+(C40/C13)*$F13*0.8125)+(D40/C13)*$F13*0.625)+(E40/C13)*$F13*0.33))","v":0}]
[]
["Fuel System","N/A",null,null,null,{"$f":"+F16","v":0}]
[]
["Instrument Approaches","N/A",null,null,null,{"$f":"+F19","v":0}]
[]
["Air Traffic Control Tower","N/A",null,null,null,{"$f":"+F21","v":0}]
[]
["Non-Hangar Buildings",{"$nulls":4},{"$f":"+IF(ISERROR(((((B48/C23)*$F23*0.9375)+(C48/C23)*$F23*0.8125)+(D48/C23)*$F23*0.625)+(E48/C23)*$F23*0.33),0,(((((B48/C23)*$F23*0.9375)+(C48/C23)*$F23*0.8125)+(D48/C23)*$F23*0.625)+(E48/C23)*$F23*0.33))","v":0}]
[]
["Existing Facility Value",{"$nulls":4},{"$f":"SUM(F31:F49)","v":0}]